Overview

Brought to you by YData

Dataset statistics

Number of variables	22
Number of observations	15222
Missing cells	39966
Missing cells (%)	11.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.6 MiB
Average record size in memory	176.0 B

Variable types

Numeric	7
DateTime	3
Categorical	9
Text	2
Unsupported	1

Alerts

`Paiement` has constant value "Carte prépayée"	Constant
`Role` has constant value "Caissier"	Constant
`Statut` has constant value "Validé"	Constant
`Client` is highly overall correlated with `ID_Client` and 6 other fields	High correlation
`ID_Client` is highly overall correlated with `Client` and 6 other fields	High correlation
`ID_Operation` is highly overall correlated with `Client` and 5 other fields	High correlation
`ID_Restaurant` is highly overall correlated with `Client` and 6 other fields	High correlation
`ID_User` is highly overall correlated with `Client` and 5 other fields	High correlation
`Montant_Rgl` is highly overall correlated with `Montant_Versé`	High correlation
`Montant_Versé` is highly overall correlated with `Montant_Rgl`	High correlation
`Prenom User` is highly overall correlated with `Client` and 5 other fields	High correlation
`Restaurant` is highly overall correlated with `Client` and 6 other fields	High correlation
`Référence` is highly overall correlated with `Client` and 3 other fields	High correlation
`ID_Client` is highly imbalanced (63.9%)	Imbalance
`Client` is highly imbalanced (63.9%)	Imbalance
`Référence` has 15123 (99.3%) missing values	Missing
`ID_Client` has 4532 (29.8%) missing values	Missing
`Client` has 4532 (29.8%) missing values	Missing
`Bénéficiaire_CPP` has 554 (3.6%) missing values	Missing
`Pointage` has 15222 (100.0%) missing values	Missing
`Montant_Rst` is highly skewed (γ1 = -45.24081811)	Skewed
`ID_Règlement` has unique values	Unique
`ID_Operation` has unique values	Unique
`Pointage` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Montant_Rst` has 15137 (99.4%) zeros	Zeros

Reproduction

Analysis started	2024-10-23 15:09:44.733242
Analysis finished	2024-10-23 15:09:56.669378
Duration	11.94 seconds
Software version	ydata-profiling vv4.11.0
Download configuration	config.json

ID_Règlement
Real number (ℝ)

Unique

Distinct	15222
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	304552.63

Minimum	250355
Maximum	388034
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.1 KiB

Quantile statistics

Minimum	250355
5-th percentile	254054.1
Q1	271202.75
median	299481.5
Q3	334226.75
95-th percentile	382797.8
Maximum	388034
Range	137679
Interquartile range (IQR)	63024

Descriptive statistics

Standard deviation	38098.098
Coefficient of variation (CV)	0.12509528
Kurtosis	-0.79294062
Mean	304552.63
Median Absolute Deviation (MAD)	30849
Skewness	0.45270286
Sum	4.6359002 × 10⁹
Variance	1.451465 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
388034	1	< 0.1%
287967	1	< 0.1%
287983	1	< 0.1%
287994	1	< 0.1%
282957	1	< 0.1%
282972	1	< 0.1%
286068	1	< 0.1%
286072	1	< 0.1%
286076	1	< 0.1%
286079	1	< 0.1%
Other values (15212)	15212	99.9%

Value	Count	Frequency (%)
250355	1	< 0.1%
250356	1	< 0.1%
250358	1	< 0.1%
250364	1	< 0.1%
250365	1	< 0.1%
250367	1	< 0.1%
250372	1	< 0.1%
250377	1	< 0.1%
250384	1	< 0.1%
250386	1	< 0.1%

Value	Count	Frequency (%)
388034	1	< 0.1%
388014	1	< 0.1%
387991	1	< 0.1%
387944	1	< 0.1%
387932	1	< 0.1%
387930	1	< 0.1%
387914	1	< 0.1%
387912	1	< 0.1%
387897	1	< 0.1%
387748	1	< 0.1%

ID_Operation
Real number (ℝ)

High correlation Unique

Distinct	15222
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.4159311 × 10⁸

Minimum	2.0190157 × 10⁸
Maximum	9.0610577 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.1 KiB

Quantile statistics

Minimum	2.0190157 × 10⁸
5-th percentile	4.0044006 × 10⁸
Q1	5.0051582 × 10⁸
median	7.0087133 × 10⁸
Q3	7.0089721 × 10⁸
95-th percentile	9.0312642 × 10⁸
Maximum	9.0610577 × 10⁸
Range	7.042042 × 10⁸
Interquartile range (IQR)	2.0038139 × 10⁸

Descriptive statistics

Standard deviation	1.4827257 × 10⁸
Coefficient of variation (CV)	0.23110062
Kurtosis	-0.68986602
Mean	6.4159311 × 10⁸
Median Absolute Deviation (MAD)	35857.5
Skewness	-0.11835631
Sum	9.7663303 × 10¹²
Variance	2.1984754 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
700915738	1	< 0.1%
700877295	1	< 0.1%
700877305	1	< 0.1%
700877312	1	< 0.1%
700874995	1	< 0.1%
700874999	1	< 0.1%
700876410	1	< 0.1%
700876413	1	< 0.1%
700876415	1	< 0.1%
700876417	1	< 0.1%
Other values (15212)	15212	99.9%

Value	Count	Frequency (%)
201901567	1	< 0.1%
201901569	1	< 0.1%
201901571	1	< 0.1%
201901572	1	< 0.1%
201901573	1	< 0.1%
201901574	1	< 0.1%
400437757	1	< 0.1%
400437758	1	< 0.1%
400437759	1	< 0.1%
400437761	1	< 0.1%

Value	Count	Frequency (%)
906105768	1	< 0.1%
906105735	1	< 0.1%
906105731	1	< 0.1%
906105705	1	< 0.1%
906105699	1	< 0.1%
906105698	1	< 0.1%
906105694	1	< 0.1%
906105691	1	< 0.1%
906105690	1	< 0.1%
906105689	1	< 0.1%

Date_Règlement
Date

Distinct	243
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Memory size	119.1 KiB

Minimum	2024-01-01 00:00:00
Maximum	2024-09-04 00:00:00

Histogram with fixed size bins (bins=50)

Heure_Règlement
Date

Distinct	12870
Distinct (%)	84.5%
Missing	0
Missing (%)	0.0%
Memory size	119.1 KiB

Minimum	2024-10-23 01:09:21
Maximum	2024-10-23 23:47:44

Histogram with fixed size bins (bins=50)

Paiement
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	119.1 KiB

Carte prépayée	15222

Length

Max length	14
Median length	14
Mean length	14
Min length	14

Characters and Unicode

Total characters	213108
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Carte prépayée
2nd row	Carte prépayée
3rd row	Carte prépayée
4th row	Carte prépayée
5th row	Carte prépayée

Common Values

Value	Count	Frequency (%)
Carte prépayée	15222	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
carte	15222	50.0%
prépayée	15222	50.0%

Most occurring characters

Value	Count	Frequency (%)
a	30444	14.3%
é	30444	14.3%
r	30444	14.3%
e	30444	14.3%
p	30444	14.3%
C	15222	7.1%
t	15222	7.1%
	15222	7.1%
y	15222	7.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	213108	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	30444	14.3%
é	30444	14.3%
r	30444	14.3%
e	30444	14.3%
p	30444	14.3%
C	15222	7.1%
t	15222	7.1%
	15222	7.1%
y	15222	7.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	213108	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	30444	14.3%
é	30444	14.3%
r	30444	14.3%
e	30444	14.3%
p	30444	14.3%
C	15222	7.1%
t	15222	7.1%
	15222	7.1%
y	15222	7.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	213108	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	30444	14.3%
é	30444	14.3%
r	30444	14.3%
e	30444	14.3%
p	30444	14.3%
C	15222	7.1%
t	15222	7.1%
	15222	7.1%
y	15222	7.1%

Référence
Real number (ℝ)

High correlation Missing

Distinct	42
Distinct (%)	42.4%
Missing	15123
Missing (%)	99.3%
Infinite	0
Infinite (%)	0.0%
Mean	5.5411145 × 10¹⁵

Minimum	585
Maximum	9.9424452 × 10¹⁵
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.1 KiB

Quantile statistics

Minimum	585
5-th percentile	1.1327267 × 10¹⁵
Q1	2.7593463 × 10¹⁵
median	4.2933584 × 10¹⁵
Q3	9.4323998 × 10¹⁵
95-th percentile	9.9283249 × 10¹⁵
Maximum	9.9424452 × 10¹⁵
Range	9.9424452 × 10¹⁵
Interquartile range (IQR)	6.6730535 × 10¹⁵

Descriptive statistics

Standard deviation	3.2404459 × 10¹⁵
Coefficient of variation (CV)	0.58480039
Kurtosis	-1.4408955
Mean	5.5411145 × 10¹⁵
Median Absolute Deviation (MAD)	1.8670205 × 10¹⁵
Skewness	0.17979743
Sum	5.4857034 × 10¹⁷
Variance	1.050049 × 10³¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
3.751365738 × 10¹⁵	14	0.1%
9.432399813 × 10¹⁵	12	0.1%
2.426337889 × 10¹⁵	10	0.1%
2.759346313 × 10¹⁵	8	0.1%
5.798735672 × 10¹⁵	8	0.1%
9.928324916 × 10¹⁵	4	< 0.1%
9.942445182 × 10¹⁵	4	< 0.1%
4.484248832 × 10¹⁵	2	< 0.1%
2.863716814 × 10¹⁵	2	< 0.1%
2.388218227 × 10¹⁵	2	< 0.1%
Other values (32)	33	0.2%
(Missing)	15123	99.3%

Value	Count	Frequency (%)
585	1	< 0.1%
904	1	< 0.1%
1246	1	< 0.1%
6024	1	< 0.1%
6537	1	< 0.1%
1.258585224 × 10¹⁵	1	< 0.1%
1.461162782 × 10¹⁵	1	< 0.1%
2.388218227 × 10¹⁵	2	< 0.1%
2.426337889 × 10¹⁵	10	0.1%
2.759346313 × 10¹⁵	8	0.1%

Value	Count	Frequency (%)
9.942445182 × 10¹⁵	4	< 0.1%
9.928324916 × 10¹⁵	4	< 0.1%
9.921822518 × 10¹⁵	1	< 0.1%
9.867569317 × 10¹⁵	1	< 0.1%
9.854852615 × 10¹⁵	1	< 0.1%
9.854337879 × 10¹⁵	1	< 0.1%
9.849287978 × 10¹⁵	1	< 0.1%
9.694836984 × 10¹⁵	1	< 0.1%
9.484145895 × 10¹⁵	1	< 0.1%
9.432399813 × 10¹⁵	12	0.1%

Montant_Rgl
Real number (ℝ)

High correlation

Distinct	401
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.954553

Minimum	1.5
Maximum	2799.528
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.1 KiB

Quantile statistics

Minimum	1.5
5-th percentile	3.5
Q1	10
median	24
Q3	45
95-th percentile	85
Maximum	2799.528
Range	2798.028
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	59.042239
Coefficient of variation (CV)	1.7388608
Kurtosis	657.75272
Mean	33.954553
Median Absolute Deviation (MAD)	16
Skewness	19.732976
Sum	516856.2
Variance	3485.986
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	997	6.5%
40	728	4.8%
15	706	4.6%
10	612	4.0%
30	543	3.6%
8	498	3.3%
18	438	2.9%
20	421	2.8%
45	410	2.7%
5	383	2.5%
Other values (391)	9486	62.3%

Value	Count	Frequency (%)
1.5	116	0.8%
2	317	2.1%
2.5	62	0.4%
3	200	1.3%
3.5	115	0.8%
4	333	2.2%
4.5	152	1.0%
5	383	2.5%
5.5	146	1.0%
6	203	1.3%

Value	Count	Frequency (%)
2799.527996	1	< 0.1%
2373.942528	1	< 0.1%
1800	1	< 0.1%
1589.951992	1	< 0.1%
1574.750015	1	< 0.1%
1380.32	1	< 0.1%
1292.47821	1	< 0.1%
1005	1	< 0.1%
974.9080048	1	< 0.1%
971.57201	1	< 0.1%

Montant_Versé
Real number (ℝ)

High correlation

Distinct	400
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.954553

Minimum	1.5
Maximum	2799.5281
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.1 KiB

Quantile statistics

Minimum	1.5
5-th percentile	3.5
Q1	10
median	24
Q3	45
95-th percentile	85
Maximum	2799.5281
Range	2798.0281
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	59.04224
Coefficient of variation (CV)	1.7388608
Kurtosis	657.75276
Mean	33.954553
Median Absolute Deviation (MAD)	16
Skewness	19.732977
Sum	516856.2
Variance	3485.9861
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	997	6.5%
40	728	4.8%
15	706	4.6%
10	612	4.0%
30	543	3.6%
8	498	3.3%
18	438	2.9%
20	421	2.8%
45	410	2.7%
5	383	2.5%
Other values (390)	9486	62.3%

Value	Count	Frequency (%)
1.5	116	0.8%
2	317	2.1%
2.5	62	0.4%
3	200	1.3%
3.5	115	0.8%
4	333	2.2%
4.5	152	1.0%
5	383	2.5%
5.5	146	1.0%
6	203	1.3%

Value	Count	Frequency (%)
2799.528076	1	< 0.1%
2373.942627	1	< 0.1%
1800	1	< 0.1%
1589.952026	1	< 0.1%
1574.75	1	< 0.1%
1380.319946	1	< 0.1%
1292.478271	1	< 0.1%
1005	1	< 0.1%
974.90802	1	< 0.1%
971.5720215	1	< 0.1%

Montant_Rst
Real number (ℝ)

Skewed Zeros

Distinct	59
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-1.4065161 × 10^-8

Minimum	-9.9182125 × 10^-5
Maximum	5.3405757 × 10^-5
Zeros	15137
Zeros (%)	99.4%
Negative	36
Negative (%)	0.2%
Memory size	119.1 KiB

Quantile statistics

Minimum	-9.9182125 × 10^-5
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	5.3405757 × 10^-5
Range	0.00015258788
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.3204659 × 10^-6
Coefficient of variation (CV)	-93.882029
Kurtosis	3499.9075
Mean	-1.4065161 × 10^-8
Median Absolute Deviation (MAD)	0
Skewness	-45.240818
Sum	-0.00021409989
Variance	1.7436302 × 10^-12
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	15137	99.4%
4.97379915 × 10^-14	8	0.1%
4.618527782 × 10^-14	8	0.1%
-3.730349363 × 10^-14	4	< 0.1%
-3.97903932 × 10^-13	3	< 0.1%
-2.486899575 × 10^-14	2	< 0.1%
-7.105427358 × 10^-15	2	< 0.1%
-7.629394389 × 10^-6	2	< 0.1%
-7.629394986 × 10^-6	2	< 0.1%
3.730349363 × 10^-14	2	< 0.1%
Other values (49)	52	0.3%

Value	Count	Frequency (%)
-9.918212481 × 10^-5	1	< 0.1%
-8.010864485 × 10^-5	1	< 0.1%
-6.103515511 × 10^-5	1	< 0.1%
-3.433227744 × 10^-5	1	< 0.1%
-1.525878952 × 10^-5	1	< 0.1%
-1.525878929 × 10^-5	1	< 0.1%
-1.144409202 × 10^-5	1	< 0.1%
-7.629394986 × 10^-6	2	< 0.1%
-7.629394389 × 10^-6	2	< 0.1%
-7.629394247 × 10^-6	1	< 0.1%

Value	Count	Frequency (%)
5.34057574 × 10^-5	1	< 0.1%
2.288818371 × 10^-5	1	< 0.1%
2.288818325 × 10^-5	1	< 0.1%
1.525878997 × 10^-5	1	< 0.1%
1.144409225 × 10^-5	1	< 0.1%
7.629394986 × 10^-6	1	< 0.1%
7.629394304 × 10^-6	1	< 0.1%
3.814696811 × 10^-6	1	< 0.1%
2.145767255 × 10^-6	1	< 0.1%
1.907349002 × 10^-6	1	< 0.1%

ID_Client
Categorical

High correlation Imbalance Missing

Distinct	2
Distinct (%)	< 0.1%
Missing	4532
Missing (%)	29.8%
Memory size	119.1 KiB

CLT10001	9955
CLT10002	735

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	85520
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CLT10001
2nd row	CLT10001
3rd row	CLT10001
4th row	CLT10001
5th row	CLT10001

Common Values

Value	Count	Frequency (%)
CLT10001	9955	65.4%
CLT10002	735	4.8%
(Missing)	4532	29.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
clt10001	9955	93.1%
clt10002	735	6.9%

Most occurring characters

Value	Count	Frequency (%)
0	32070	37.5%
1	20645	24.1%
L	10690	12.5%
C	10690	12.5%
T	10690	12.5%
2	735	0.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	85520	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	32070	37.5%
1	20645	24.1%
L	10690	12.5%
C	10690	12.5%
T	10690	12.5%
2	735	0.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	85520	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	32070	37.5%
1	20645	24.1%
L	10690	12.5%
C	10690	12.5%
T	10690	12.5%
2	735	0.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	85520	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	32070	37.5%
1	20645	24.1%
L	10690	12.5%
C	10690	12.5%
T	10690	12.5%
2	735	0.9%

Client
Categorical

High correlation Imbalance Missing

Distinct	2
Distinct (%)	< 0.1%
Missing	4532
Missing (%)	29.8%
Memory size	119.1 KiB

CLIENT AU COMPTANT	9955
CLIENT CARTE PRÉPAYÉE	735

Length

Max length	21
Median length	18
Mean length	18.206268
Min length	18

Characters and Unicode

Total characters	194625
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CLIENT AU COMPTANT
2nd row	CLIENT AU COMPTANT
3rd row	CLIENT AU COMPTANT
4th row	CLIENT AU COMPTANT
5th row	CLIENT AU COMPTANT

Common Values

Value	Count	Frequency (%)
CLIENT AU COMPTANT	9955	65.4%
CLIENT CARTE PRÉPAYÉE	735	4.8%
(Missing)	4532	29.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
client	10690	33.3%
au	9955	31.0%
comptant	9955	31.0%
carte	735	2.3%
prépayée	735	2.3%

Most occurring characters

Value	Count	Frequency (%)
T	31335	16.1%
	21380	11.0%
C	21380	11.0%
A	21380	11.0%
N	20645	10.6%
E	12160	6.2%
P	11425	5.9%
L	10690	5.5%
I	10690	5.5%
O	9955	5.1%
Other values (5)	23585	12.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	194625	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
T	31335	16.1%
	21380	11.0%
C	21380	11.0%
A	21380	11.0%
N	20645	10.6%
E	12160	6.2%
P	11425	5.9%
L	10690	5.5%
I	10690	5.5%
O	9955	5.1%
Other values (5)	23585	12.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	194625	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
T	31335	16.1%
	21380	11.0%
C	21380	11.0%
A	21380	11.0%
N	20645	10.6%
E	12160	6.2%
P	11425	5.9%
L	10690	5.5%
I	10690	5.5%
O	9955	5.1%
Other values (5)	23585	12.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	194625	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
T	31335	16.1%
	21380	11.0%
C	21380	11.0%
A	21380	11.0%
N	20645	10.6%
E	12160	6.2%
P	11425	5.9%
L	10690	5.5%
I	10690	5.5%
O	9955	5.1%
Other values (5)	23585	12.1%

ID_CartePP
Text

Distinct	1007
Distinct (%)	6.6%
Missing	0
Missing (%)	0.0%
Memory size	119.1 KiB

Length

Max length	19
Median length	16
Mean length	16.012416
Min length	5

Characters and Unicode

Total characters	243741
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	212 ?
Unique (%)	1.4%

Sample

1st row	1237736457745921
2nd row	9854337878921188
3rd row	4284648158394883
4th row	3628329735567861
5th row	9536648418398212

Value	Count	Frequency (%)
4284648158394883	278	1.8%
1461162782251889	275	1.8%
6632395296331911	249	1.6%
2863716813744826	242	1.6%
5676118786483647	239	1.6%
2426337888522318	227	1.5%
2298119326996171	213	1.4%
1271645626186163	201	1.3%
1443451317787646	197	1.3%
1258585224496584	196	1.3%
Other values (997)	12905	84.8%

Most occurring characters

Value	Count	Frequency (%)
1	28792	11.8%
4	28680	11.8%
3	28423	11.7%
2	28229	11.6%
8	28178	11.6%
6	27496	11.3%
9	27268	11.2%
5	23403	9.6%
7	22266	9.1%
0	382	0.2%
Other values (11)	624	0.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	243741	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	28792	11.8%
4	28680	11.8%
3	28423	11.7%
2	28229	11.6%
8	28178	11.6%
6	27496	11.3%
9	27268	11.2%
5	23403	9.6%
7	22266	9.1%
0	382	0.2%
Other values (11)	624	0.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	243741	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	28792	11.8%
4	28680	11.8%
3	28423	11.7%
2	28229	11.6%
8	28178	11.6%
6	27496	11.3%
9	27268	11.2%
5	23403	9.6%
7	22266	9.1%
0	382	0.2%
Other values (11)	624	0.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	243741	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	28792	11.8%
4	28680	11.8%
3	28423	11.7%
2	28229	11.6%
8	28178	11.6%
6	27496	11.3%
9	27268	11.2%
5	23403	9.6%
7	22266	9.1%
0	382	0.2%
Other values (11)	624	0.3%

Bénéficiaire_CPP
Text

Missing

Distinct	855
Distinct (%)	5.8%
Missing	554
Missing (%)	3.6%
Memory size	119.1 KiB

Length

Max length	28
Median length	21
Mean length	8.8797382
Min length	2

Characters and Unicode

Total characters	130248
Distinct characters	50
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	164 ?
Unique (%)	1.1%

Sample

1st row	MOUMOUN
2nd row	FARAIDI
3rd row	RACHIDI Salah
4th row	EL AZRAK
5th row	ZERIOUEL

Value	Count	Frequency (%)
el	2031	10.0%
mohamed	821	4.1%
yao	494	2.4%
salah	295	1.5%
rachidi	295	1.5%
djeth	289	1.4%
doudouh	272	1.3%
selmani	255	1.3%
nait	245	1.2%
yazza	244	1.2%
Other values (911)	14986	74.1%

Most occurring characters

Value	Count	Frequency (%)
A	19759	15.2%
I	11027	8.5%
E	10094	7.7%
O	8133	6.2%
H	7425	5.7%
L	6887	5.3%
M	6476	5.0%
U	6454	5.0%
R	5903	4.5%
D	5784	4.4%
Other values (40)	42306	32.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	130248	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	19759	15.2%
I	11027	8.5%
E	10094	7.7%
O	8133	6.2%
H	7425	5.7%
L	6887	5.3%
M	6476	5.0%
U	6454	5.0%
R	5903	4.5%
D	5784	4.4%
Other values (40)	42306	32.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	130248	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	19759	15.2%
I	11027	8.5%
E	10094	7.7%
O	8133	6.2%
H	7425	5.7%
L	6887	5.3%
M	6476	5.0%
U	6454	5.0%
R	5903	4.5%
D	5784	4.4%
Other values (40)	42306	32.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	130248	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	19759	15.2%
I	11027	8.5%
E	10094	7.7%
O	8133	6.2%
H	7425	5.7%
L	6887	5.3%
M	6476	5.0%
U	6454	5.0%
R	5903	4.5%
D	5784	4.4%
Other values (40)	42306	32.5%

Solde_CPP
Real number (ℝ)

Distinct	5346
Distinct (%)	35.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	631.31823

Minimum	1.5
Maximum	6000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	119.1 KiB

Quantile statistics

Minimum	1.5
5-th percentile	22.5
Q1	100
median	330
Q3	960.875
95-th percentile	1904.3
Maximum	6000
Range	5998.5
Interquartile range (IQR)	860.875

Descriptive statistics

Standard deviation	671.6558
Coefficient of variation (CV)	1.0638942
Kurtosis	0.65377392
Mean	631.31823
Median Absolute Deviation (MAD)	279
Skewness	1.1439607
Sum	9609926.2
Variance	451121.51
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1903.1	108	0.7%
100	102	0.7%
1904.1	79	0.5%
1903.3	63	0.4%
1902.1	61	0.4%
1903.11	59	0.4%
1902.12	59	0.4%
1903.12	58	0.4%
1903.9	58	0.4%
200	57	0.4%
Other values (5336)	14518	95.4%

Value	Count	Frequency (%)
1.5	3	< 0.1%
2	7	< 0.1%
2.5	9	0.1%
3	11	0.1%
3.14	1	< 0.1%
3.5	12	0.1%
4	7	< 0.1%
4.5	7	< 0.1%
5	20	0.1%
5.28	1	< 0.1%

Value	Count	Frequency (%)
6000	1	< 0.1%
5000	1	< 0.1%
4995	1	< 0.1%
4955	1	< 0.1%
4946	1	< 0.1%
4940	1	< 0.1%
4905	1	< 0.1%
3945.63	1	< 0.1%
3881.57	1	< 0.1%
3406.5	1	< 0.1%

ID_Restaurant
Categorical

High correlation

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	119.1 KiB

RST10005	8152
RST10003	4639
RST10012	1111
RST10010	641
RST10014	528
Other values (2)	151

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	121776
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RST10005
2nd row	RST10005
3rd row	RST10005
4th row	RST10005
5th row	RST10005

Common Values

Value	Count	Frequency (%)
RST10005	8152	53.6%
RST10003	4639	30.5%
RST10012	1111	7.3%
RST10010	641	4.2%
RST10014	528	3.5%
RST10006	94	0.6%
RST10004	57	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
rst10005	8152	53.6%
rst10003	4639	30.5%
rst10012	1111	7.3%
rst10010	641	4.2%
rst10014	528	3.5%
rst10006	94	0.6%
rst10004	57	0.4%

Most occurring characters

Value	Count	Frequency (%)
0	44027	36.2%
1	17502	14.4%
S	15222	12.5%
R	15222	12.5%
T	15222	12.5%
5	8152	6.7%
3	4639	3.8%
2	1111	0.9%
4	585	0.5%
6	94	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	121776	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	44027	36.2%
1	17502	14.4%
S	15222	12.5%
R	15222	12.5%
T	15222	12.5%
5	8152	6.7%
3	4639	3.8%
2	1111	0.9%
4	585	0.5%
6	94	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	121776	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	44027	36.2%
1	17502	14.4%
S	15222	12.5%
R	15222	12.5%
T	15222	12.5%
5	8152	6.7%
3	4639	3.8%
2	1111	0.9%
4	585	0.5%
6	94	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	121776	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	44027	36.2%
1	17502	14.4%
S	15222	12.5%
R	15222	12.5%
T	15222	12.5%
5	8152	6.7%
3	4639	3.8%
2	1111	0.9%
4	585	0.5%
6	94	0.1%

Restaurant
Categorical

High correlation

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	119.1 KiB

Café - Boulangerie - Pâtisserie - Rabat	8152
Snack Pizzeria - Rabat	4639
L'Casis Cafétéria HCZ	1111
Lavomatic - Rabat	641
Epicerie - Rabat	528
Other values (2)	151

Length

Max length	39
Median length	39
Mean length	30.717908
Min length	16

Characters and Unicode

Total characters	467588
Distinct characters	37
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Café - Boulangerie - Pâtisserie - Rabat
2nd row	Café - Boulangerie - Pâtisserie - Rabat
3rd row	Café - Boulangerie - Pâtisserie - Rabat
4th row	Café - Boulangerie - Pâtisserie - Rabat
5th row	Café - Boulangerie - Pâtisserie - Rabat

Common Values

Value	Count	Frequency (%)
Café - Boulangerie - Pâtisserie - Rabat	8152	53.6%
Snack Pizzeria - Rabat	4639	30.5%
L'Casis Cafétéria HCZ	1111	7.3%
Lavomatic - Rabat	641	4.2%
Epicerie - Rabat	528	3.5%
Pharmacie & Parapharmacie - Rabat	94	0.6%
Restaurant Gastronomique - Rabat	57	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
	30509	36.7%
rabat	14111	17.0%
boulangerie	8152	9.8%
café	8152	9.8%
pâtisserie	8152	9.8%
snack	4639	5.6%
pizzeria	4639	5.6%
l'casis	1111	1.3%
cafétéria	1111	1.3%
hcz	1111	1.3%
Other values (6)	1471	1.8%

Most occurring characters

Value	Count	Frequency (%)
	67936	14.5%
a	59154	12.7%
e	38605	8.3%
i	37898	8.1%
-	30415	6.5%
t	24186	5.2%
r	22978	4.9%
s	18640	4.0%
R	14168	3.0%
b	14111	3.0%
Other values (27)	139497	29.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	467588	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	67936	14.5%
a	59154	12.7%
e	38605	8.3%
i	37898	8.1%
-	30415	6.5%
t	24186	5.2%
r	22978	4.9%
s	18640	4.0%
R	14168	3.0%
b	14111	3.0%
Other values (27)	139497	29.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	467588	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	67936	14.5%
a	59154	12.7%
e	38605	8.3%
i	37898	8.1%
-	30415	6.5%
t	24186	5.2%
r	22978	4.9%
s	18640	4.0%
R	14168	3.0%
b	14111	3.0%
Other values (27)	139497	29.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	467588	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	67936	14.5%
a	59154	12.7%
e	38605	8.3%
i	37898	8.1%
-	30415	6.5%
t	24186	5.2%
r	22978	4.9%
s	18640	4.0%
R	14168	3.0%
b	14111	3.0%
Other values (27)	139497	29.8%

ID_User
Categorical

High correlation

Distinct	13
Distinct (%)	0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	119.1 KiB

USR10004	4158
USR10003	3581
USR10008	2348
USR10002	1963
USR10001	797
Other values (8)	2374

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	121768
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	USR10004
2nd row	USR10004
3rd row	USR10004
4th row	USR10004
5th row	USR10004

Common Values

Value	Count	Frequency (%)
USR10004	4158	27.3%
USR10003	3581	23.5%
USR10008	2348	15.4%
USR10002	1963	12.9%
USR10001	797	5.2%
USR10022	641	4.2%
USR10023	515	3.4%
USR10024	361	2.4%
USR10029	324	2.1%
USR10027	235	1.5%
Other values (3)	298	2.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
usr10004	4158	27.3%
usr10003	3581	23.5%
usr10008	2348	15.4%
usr10002	1963	12.9%
usr10001	797	5.2%
usr10022	641	4.2%
usr10023	515	3.4%
usr10024	361	2.4%
usr10029	324	2.1%
usr10027	235	1.5%
Other values (3)	298	2.0%

Most occurring characters

Value	Count	Frequency (%)
0	43493	35.7%
1	16018	13.2%
S	15221	12.5%
U	15221	12.5%
R	15221	12.5%
2	4774	3.9%
4	4519	3.7%
3	4300	3.5%
8	2416	2.0%
9	324	0.3%
Other values (2)	261	0.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	121768	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	43493	35.7%
1	16018	13.2%
S	15221	12.5%
U	15221	12.5%
R	15221	12.5%
2	4774	3.9%
4	4519	3.7%
3	4300	3.5%
8	2416	2.0%
9	324	0.3%
Other values (2)	261	0.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	121768	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	43493	35.7%
1	16018	13.2%
S	15221	12.5%
U	15221	12.5%
R	15221	12.5%
2	4774	3.9%
4	4519	3.7%
3	4300	3.5%
8	2416	2.0%
9	324	0.3%
Other values (2)	261	0.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	121768	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	43493	35.7%
1	16018	13.2%
S	15221	12.5%
U	15221	12.5%
R	15221	12.5%
2	4774	3.9%
4	4519	3.7%
3	4300	3.5%
8	2416	2.0%
9	324	0.3%
Other values (2)	261	0.2%

Prenom User
Categorical

High correlation

Distinct	12
Distinct (%)	0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	119.1 KiB

Souhail	4311
Hamza	4158
Soundoss	3581
Ayoub	797
Fadwa	641
Other values (7)	1733

Length

Max length	10
Median length	9
Mean length	6.5225018
Min length	5

Characters and Unicode

Total characters	99279
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Hamza
2nd row	Hamza
3rd row	Hamza
4th row	Hamza
5th row	Hamza

Common Values

Value	Count	Frequency (%)
Souhail	4311	28.3%
Hamza	4158	27.3%
Soundoss	3581	23.5%
Ayoub	797	5.2%
Fadwa	641	4.2%
Abdelkarim	515	3.4%
Morad	361	2.4%
Moncef	324	2.1%
Ayman	235	1.5%
Abdelkrim	204	1.3%
Other values (2)	94	0.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
souhail	4311	28.3%
hamza	4158	27.3%
soundoss	3581	23.5%
ayoub	797	5.2%
fadwa	641	4.2%
abdelkarim	515	3.4%
morad	361	2.4%
moncef	324	2.1%
ayman	235	1.5%
abdelkrim	204	1.3%
Other values (2)	94	0.6%

Most occurring characters

Value	Count	Frequency (%)
a	15140	15.2%
o	13023	13.1%
u	8757	8.8%
S	7892	7.9%
s	7162	7.2%
d	5370	5.4%
m	5112	5.1%
i	5030	5.1%
l	5030	5.1%
h	4311	4.3%
Other values (16)	22452	22.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	99279	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	15140	15.2%
o	13023	13.1%
u	8757	8.8%
S	7892	7.9%
s	7162	7.2%
d	5370	5.4%
m	5112	5.1%
i	5030	5.1%
l	5030	5.1%
h	4311	4.3%
Other values (16)	22452	22.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	99279	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	15140	15.2%
o	13023	13.1%
u	8757	8.8%
S	7892	7.9%
s	7162	7.2%
d	5370	5.4%
m	5112	5.1%
i	5030	5.1%
l	5030	5.1%
h	4311	4.3%
Other values (16)	22452	22.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	99279	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	15140	15.2%
o	13023	13.1%
u	8757	8.8%
S	7892	7.9%
s	7162	7.2%
d	5370	5.4%
m	5112	5.1%
i	5030	5.1%
l	5030	5.1%
h	4311	4.3%
Other values (16)	22452	22.6%

Role
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	119.1 KiB

Caissier	15221

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	121768
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Caissier
2nd row	Caissier
3rd row	Caissier
4th row	Caissier
5th row	Caissier

Common Values

Value	Count	Frequency (%)
Caissier	15221	> 99.9%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
caissier	15221	100.0%

Most occurring characters

Value	Count	Frequency (%)
s	30442	25.0%
i	30442	25.0%
a	15221	12.5%
C	15221	12.5%
e	15221	12.5%
r	15221	12.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	121768	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	30442	25.0%
i	30442	25.0%
a	15221	12.5%
C	15221	12.5%
e	15221	12.5%
r	15221	12.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	121768	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	30442	25.0%
i	30442	25.0%
a	15221	12.5%
C	15221	12.5%
e	15221	12.5%
r	15221	12.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	121768	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	30442	25.0%
i	30442	25.0%
a	15221	12.5%
C	15221	12.5%
e	15221	12.5%
r	15221	12.5%

Statut
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	119.1 KiB

Validé	15222

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	91332
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Validé
2nd row	Validé
3rd row	Validé
4th row	Validé
5th row	Validé

Common Values

Value	Count	Frequency (%)
Validé	15222	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
validé	15222	100.0%

Most occurring characters

Value	Count	Frequency (%)
V	15222	16.7%
a	15222	16.7%
l	15222	16.7%
i	15222	16.7%
d	15222	16.7%
é	15222	16.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	91332	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
V	15222	16.7%
a	15222	16.7%
l	15222	16.7%
i	15222	16.7%
d	15222	16.7%
é	15222	16.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	91332	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
V	15222	16.7%
a	15222	16.7%
l	15222	16.7%
i	15222	16.7%
d	15222	16.7%
é	15222	16.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	91332	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
V	15222	16.7%
a	15222	16.7%
l	15222	16.7%
i	15222	16.7%
d	15222	16.7%
é	15222	16.7%

Pointage
Unsupported

Missing Rejected Unsupported

Missing	15222
Missing (%)	100.0%
Memory size	119.1 KiB

Date_Sys
Date

Distinct	243
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Memory size	119.1 KiB

Minimum	2024-01-01 00:00:00
Maximum	2024-09-04 00:00:00

Histogram with fixed size bins (bins=50)

Interactions

Correlations

	Client	ID_Client	ID_Operation	ID_Restaurant	ID_Règlement	ID_User	Montant_Rgl	Montant_Rst	Montant_Versé	Prenom User	Restaurant	Référence	Solde_CPP
Client	1.000	0.999	0.891	1.000	0.122	0.999	0.155	0.130	0.155	1.000	1.000	0.962	0.093
ID_Client	0.999	1.000	0.891	1.000	0.122	0.999	0.155	0.130	0.155	1.000	1.000	0.962	0.093
ID_Operation	0.891	0.891	1.000	0.722	0.328	0.569	-0.405	0.012	-0.405	0.567	0.722	0.266	-0.241
ID_Restaurant	1.000	1.000	0.722	1.000	0.311	0.893	0.246	0.155	0.246	0.892	1.000	0.510	0.155
ID_Règlement	0.122	0.122	0.328	0.311	1.000	0.271	0.088	0.017	0.088	0.270	0.311	0.278	0.098
ID_User	0.999	0.999	0.569	0.893	0.271	1.000	0.203	0.169	0.203	1.000	0.893	0.369	0.134
Montant_Rgl	0.155	0.155	-0.405	0.246	0.088	0.203	1.000	0.002	1.000	0.203	0.246	0.120	0.305
Montant_Rst	0.130	0.130	0.012	0.155	0.017	0.169	0.002	1.000	0.002	0.169	0.155	-0.145	0.008
Montant_Versé	0.155	0.155	-0.405	0.246	0.088	0.203	1.000	0.002	1.000	0.203	0.246	0.120	0.305
Prenom User	1.000	1.000	0.567	0.892	0.270	1.000	0.203	0.169	0.203	1.000	0.892	0.423	0.134
Restaurant	1.000	1.000	0.722	1.000	0.311	0.893	0.246	0.155	0.246	0.892	1.000	0.510	0.155
Référence	0.962	0.962	0.266	0.510	0.278	0.369	0.120	-0.145	0.120	0.423	0.510	1.000	-0.058
Solde_CPP	0.093	0.093	-0.241	0.155	0.098	0.134	0.305	0.008	0.305	0.134	0.155	-0.058	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	ID_Règlement	ID_Operation	Date_Règlement	Heure_Règlement	Paiement	Référence	Montant_Rgl	Montant_Versé	ID_Client	Client	ID_CartePP	Bénéficiaire_CPP	Solde_CPP	ID_Restaurant	Restaurant	ID_User	Prenom User	Role	Statut	Pointage	Date_Sys
0	287967	700877295	2024-02-29	08:07:37	Carte prépayée	NaN	13.5	13.5	CLT10001	CLIENT AU COMPTANT	1237736457745921	MOUMOUN	952.00	RST10005	Café - Boulangerie - Pâtisserie - Rabat	USR10004	Hamza	Caissier	Validé	NaN	2024-02-29
1	287983	700877305	2024-02-29	08:17:54	Carte prépayée	NaN	8.0	8.0	CLT10001	CLIENT AU COMPTANT	9854337878921188	FARAIDI	921.51	RST10005	Café - Boulangerie - Pâtisserie - Rabat	USR10004	Hamza	Caissier	Validé	NaN	2024-02-29
2	287994	700877312	2024-02-29	08:23:33	Carte prépayée	NaN	20.0	20.0	CLT10001	CLIENT AU COMPTANT	4284648158394883	RACHIDI Salah	790.00	RST10005	Café - Boulangerie - Pâtisserie - Rabat	USR10004	Hamza	Caissier	Validé	NaN	2024-02-29
3	282957	700874995	2024-02-22	11:19:17	Carte prépayée	NaN	87.0	87.0	CLT10001	CLIENT AU COMPTANT	3628329735567861	EL AZRAK	346.23	RST10005	Café - Boulangerie - Pâtisserie - Rabat	USR10004	Hamza	Caissier	Validé	NaN	2024-02-22
4	282972	700874999	2024-02-22	11:31:14	Carte prépayée	NaN	5.0	5.0	CLT10001	CLIENT AU COMPTANT	9536648418398212	ZERIOUEL	875.50	RST10005	Café - Boulangerie - Pâtisserie - Rabat	USR10004	Hamza	Caissier	Validé	NaN	2024-02-22
5	286068	700876410	2024-02-27	08:16:08	Carte prépayée	NaN	8.0	8.0	CLT10001	CLIENT AU COMPTANT	3459944654116885	CHAOUNI BENABDALLAH	961.50	RST10005	Café - Boulangerie - Pâtisserie - Rabat	USR10004	Hamza	Caissier	Validé	NaN	2024-02-27
6	286072	700876413	2024-02-27	08:17:21	Carte prépayée	NaN	12.0	12.0	CLT10001	CLIENT AU COMPTANT	1468957443591868	ZAZARI	185.00	RST10005	Café - Boulangerie - Pâtisserie - Rabat	USR10004	Hamza	Caissier	Validé	NaN	2024-02-27
7	286076	700876415	2024-02-27	08:17:59	Carte prépayée	NaN	8.0	8.0	CLT10001	CLIENT AU COMPTANT	3459944654116885	CHAOUNI BENABDALLAH	953.50	RST10005	Café - Boulangerie - Pâtisserie - Rabat	USR10004	Hamza	Caissier	Validé	NaN	2024-02-27
8	286079	700876417	2024-02-27	08:19:31	Carte prépayée	NaN	45.0	45.0	CLT10001	CLIENT AU COMPTANT	2984982456498383	MAARIF	331.00	RST10005	Café - Boulangerie - Pâtisserie - Rabat	USR10004	Hamza	Caissier	Validé	NaN	2024-02-27
9	288014	700877323	2024-02-29	08:34:11	Carte prépayée	NaN	8.0	8.0	CLT10001	CLIENT AU COMPTANT	3417943491637353	EZ-ZAARATE	141.00	RST10005	Café - Boulangerie - Pâtisserie - Rabat	USR10004	Hamza	Caissier	Validé	NaN	2024-02-29

	ID_Règlement	ID_Operation	Date_Règlement	Heure_Règlement	Paiement	Référence	Montant_Rgl	Montant_Versé	ID_Client	Client	ID_CartePP	Bénéficiaire_CPP	Solde_CPP	ID_Restaurant	Restaurant	ID_User	Prenom User	Role	Statut	Pointage	Date_Sys
15212	387748	906105705	2024-09-04	07:43:20	Carte prépayée	NaN	19.0	19.0	CLT10001	CLIENT AU COMPTANT	9632819172214156	DOUDOUH	1903.30	RST10014	Epicerie - Rabat	USR10029	Moncef	Caissier	Validé	NaN	2024-09-04
15213	387897	906105731	2024-09-04	09:45:12	Carte prépayée	NaN	4.0	4.0	CLT10001	CLIENT AU COMPTANT	9697966821673656	CHERKAOUI	13.50	RST10014	Epicerie - Rabat	USR10029	Moncef	Caissier	Validé	NaN	2024-09-04
15214	387912	700915703	2024-09-04	09:58:58	Carte prépayée	NaN	13.0	13.0	CLT10001	CLIENT AU COMPTANT	9648732328734427	HANAFI	79.50	RST10005	Café - Boulangerie - Pâtisserie - Rabat	USR10004	Hamza	Caissier	Validé	NaN	2024-09-04
15215	387914	906105735	2024-09-04	10:00:14	Carte prépayée	NaN	19.0	19.0	CLT10001	CLIENT AU COMPTANT	3657743229762819	JENNANE	74.50	RST10014	Epicerie - Rabat	USR10029	Moncef	Caissier	Validé	NaN	2024-09-04
15216	387930	700915709	2024-09-04	10:10:07	Carte prépayée	NaN	4.0	4.0	CLT10001	CLIENT AU COMPTANT	9647665548393481	HANINE Mohamed	34.50	RST10005	Café - Boulangerie - Pâtisserie - Rabat	USR10004	Hamza	Caissier	Validé	NaN	2024-09-04
15217	387932	700915710	2024-09-04	10:10:28	Carte prépayée	NaN	7.0	7.0	CLT10001	CLIENT AU COMPTANT	3314783631225925	AQEL	1453.55	RST10005	Café - Boulangerie - Pâtisserie - Rabat	USR10004	Hamza	Caissier	Validé	NaN	2024-09-04
15218	387944	700915716	2024-09-04	10:20:13	Carte prépayée	NaN	35.0	35.0	CLT10001	CLIENT AU COMPTANT	9166242347522725	AIT HAJJI	6000.00	RST10005	Café - Boulangerie - Pâtisserie - Rabat	USR10004	Hamza	Caissier	Validé	NaN	2024-09-04
15219	387991	700915730	2024-09-04	10:52:03	Carte prépayée	NaN	54.0	54.0	CLT10001	CLIENT AU COMPTANT	3391323398681767	ZAGHBACH	59.00	RST10005	Café - Boulangerie - Pâtisserie - Rabat	USR10004	Hamza	Caissier	Validé	NaN	2024-09-04
15220	388014	906105768	2024-09-04	11:16:27	Carte prépayée	NaN	5.0	5.0	CLT10001	CLIENT AU COMPTANT	9364826446274539	ZAHID	66.00	RST10014	Epicerie - Rabat	USR10029	Moncef	Caissier	Validé	NaN	2024-09-04
15221	388034	700915738	2024-09-04	11:25:34	Carte prépayée	NaN	8.0	8.0	CLT10001	CLIENT AU COMPTANT	9934258673758229	REMMAL	36.50	RST10005	Café - Boulangerie - Pâtisserie - Rabat	USR10004	Hamza	Caissier	Validé	NaN	2024-09-04

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category